﻿ CREATE procedure [dbo].[usp_UpdateTechnicalTaskStatus]    
 @TechnicalTaskId as int,         
 @Status as nvarchar(50),    
 @TaskCompletedBy as nvarchar(50)
 
 as    
     
 update TblTechnicalTask set  
 Status=@Status,    
 TaskCompletedBy=@TaskCompletedBy    
 where TechnicalTaskId  = @TechnicalTaskId